package com.un.ebs.purchase.mapper;

import com.baomidou.mybatisplus.annotation.SqlParser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.un.ebs.inventory.domain.InventoryNoteItemExt;
import com.un.ebs.purchase.domain.PurchaseOrderItemExt;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * (PurchaseOrderItemExt)表数据库访问层
 *
 * @author makejava
 * @since 2020-09-01 14:52:53
 */
public interface PurchaseOrderItemExtMapper extends BaseMapper<PurchaseOrderItemExt> {

    @SqlParser(filter = true)
    @Select("select * from v_inventory_note_item_ext where relation_note_id=#{purchaseOrderId}")
    List<InventoryNoteItemExt> queryPurchaseInNote(@Param("purchaseOrderId") String purchaseOrderId);

}